package edu.maimonides.ejercicios.ides1.sql.ddl.hsql;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import edu.maimonides.ejercicios.ides1.sql.ddl.DatabaseSchemaManager;

public class HSQLDatabaseSchemaManager implements DatabaseSchemaManager {

	public void createSchema(Connection connection) throws SQLException {
		JDBCUtils.executeStatement("CREATE TABLE PERSONAS (DNI VARCHAR(10) PRIMARY KEY, NOMBRE VARCHAR(50), APELLIDO VARCHAR(50))",connection);
	}

	public void destroySchema(Connection connection) throws SQLException {
		JDBCUtils.executeStatement("DROP TABLE PERSONAS",connection);
	}

}
